This is a multi-part message in MIME format.
------=_NextPart_000_001E_01C716FF.BDB696C0
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable
Ok, I think you are misunderstanding the process:
=20
1. first, you are querying a database (I assume a postgres db) like
this:
=20
$result =3D pg_query($dbconn, =93select
) , so,
=20
$result now is a =93resource reference=94 which contains the =
=93result=94 of the
query. However, now you need to tell php to return the contents of that
resource to you (you can return in either an indexed, associative, or =
object
array). So, to get your =93array=94, you now use $result like this:
=20
$myArray =3D pg_fetch_array($result);
=20
Now $myArray is the actual =93row/s=94 you returned in $result.
=20
Does that make sense?
=20
So, when you first query, $result (or $result_ip) =3D pg_query(conn, =
sql), you
need to be consistent with your variables. Either use $result_ip, or
$result, but not both=85.My guess is that=92s your problem.
=20
Hope that helps!
Randy
_____ =20
From: pgsql-php-owner@postgresql.org =
[mailto:pgsql-php-owner@postgresql.org]
On Behalf Of Mag Gam
Sent: Sunday, December 03, 2006 5:01 PM
To: Chris
Cc: Randy Moller; pgsql-php@postgresql.org
Subject: Re: [PHP] HTML FORMS selected question
=20
Chris + Randy:
Sorry, I may of forgetten to give you this:
$result =3D pg_query($dbconn, "select id,address from ip");
This is right before the:
$options=3Dpg_fetch_array($result_ip);
so, my $results is really all the ip addresses ($rows after I perform =
the
pg_fetch_array).=20
I will add the var_dump to see it (never done it before, I will do some
googling :) )
On 12/3/06, Chris
dmagick@gmail.com>
wrote:
Mag Gam wrote:
> Randy + Chris:
>
> Thx for the quick replies!=20
>
> Chris:
>
> $rows contain ip addresses (postgresql inet) type (example: HYPERLINK
"http://192.168.0.1"192.168.0.1
> )
> $options contain ip addresses (postgresql inet0 type (example: =
HYPERLINK
"http://127.0.0.1"127.0.0.1
> )
> (keep in mind) they are both arrays. $rows contact all ips, and =
$options
> contact the ip addresses that were selected=20
>
> Randy:
> I am not sure what you mean. The variables look right. I am getting no
> errors! Just the logic is messed up.
I think Randy's right.
At the top you have:
//The values that need to be selected=20
$result_ip=3Dpg_query($dbconn,$test_query);
^^^^^^^^^
but you are doing this:
while ($row =3D pg_fetch_array($result)) {
$result_ip at the top, $result in the second bit.
If you don't see errors, turn up error reporting & display errors:=20
error_reporting(E_ALL);
ini_set('display_errors', true);
Also that's not what I meant. I meant add a var_dump or print_r at each
stage to see what you are *really* getting from the code.
--
Postgresql & php tutorials
HYPERLINK "http://www.designmagick.com/"http://www.designmagick.com/
=20
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: =
12/2/2006
9:39 PM
--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: =
12/2/2006
9:39 PM
=20
------=_NextPart_000_001E_01C716FF.BDB696C0
Content-Type: text/html;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
charset=3Dwindows-1250">
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Ok, I think you are =
misunderstanding the
process:
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
-
lfo1'>
color=3Dnavy face=3DArial>
style=3D'font-size:10.0pt;font-family:Arial'>first,
you are querying a database (I assume a postgres db) like =
this:
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>$result =3D pg_query($dbconn, =
“select…”) ,
so,
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>$result now is a “resource =
reference”
which contains the “result” of the query. However, now you =
need to tell php to
return the contents of that resource to you (you can return in either an
indexed, associative, or object array). So, to get your =
“array”, you now use
$result like this:
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>$myArray =3D =
pg_fetch_array($result);
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Now $myArray is the actual =
“row/s” you
returned in $result.
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Does that make =
sense?
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>So, when you first query, $result =
(or
$result_ip) =3D pg_query(conn, sql), you need to be consistent with your
variables. Either use $result_ip, or $result, but not both….My =
guess is that’s
your problem.
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hope that =
helps!
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Randy
size=3D3
face=3D"Times New Roman">
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:
size=3D2
face=3DTahoma>
pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] =
style=3D'font-weight:bold'>On Behalf Of Mag Gam
Sent: Sunday, December =
03, 2006
5:01 PM
To: Chris
Cc: Randy Moller;
pgsql-php@postgresql.org
Subject: Re: [PHP] HTML =
FORMS
selected question
style=3D'font-size:
12.0pt'>
face=3D"Times New Roman">Chris + =
Randy:
Sorry, I may of forgetten to give you this:
$result =3D pg_query($dbconn, "select id,address from =
ip");
This is right before the:
$options=3Dpg_fetch_array($result_ip);
so, my $results is really all the ip addresses ($rows after I perform =
the
pg_fetch_array).
I will add the var_dump to see it (never done it before, I will do some
googling :) )
face=3D"Times New Roman">
style=3D'font-size:12.0pt'>
style=3D'font-size:10.0pt'>--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: =
12/2/2006 9:39
PM